CREATE EXTERNAL TABLE `jms_dwd`.`dwd_yl_oms_order_mark_expand_base_hi`(
`id` bigint COMMENT '主键ID'
, `order_id` bigint COMMENT '订单ID'
, `waybill_id` string COMMENT '运单号'
, `order_source_code` string COMMENT '订单来源code'
, `field_name` string COMMENT '打标字段名称'
, `field_value` string COMMENT '打标字段值'
, `input_time` timestamp COMMENT '录入时间'
, `update_time` timestamp COMMENT '修改时间'
, `is_delete` bigint COMMENT '是否删除 1：未删除 2：已删除'
)
COMMENT '订单打标拓展表'
PARTITIONED BY (`dt` string COMMENT '分区(yyyy-mm-dd)')
ROW FORMAT SERDE 'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'
WITH SERDEPROPERTIES (
  'serialization.format' = '1'
)
STORED AS
  INPUTFORMAT 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat'
  OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat'
LOCATION 'hdfs://yl-bg-hdp/dw/hive/jms_dwd.db/external/dwd_yl_oms_order_mark_expand_base_hi'
TBLPROPERTIES (
  'bucketing_version' = '2',
  'transient_lastDdlTime' = '1675647518',
  'discover.partitions' = 'true'
)